UC知道[高分]ASP 怎样只显示5条数据,高手请帮帮忙谢谢~!
来源：百度知道 编辑：UC知道 时间：2024/09/25 13:23:45
以下是代码:请高手帮帮我,急~!..
网页地址是http://www.xiangyilxj.com/consultation/consultation.asp
就是把这里的留言只显示5条.
<table width="540" border="0" align="center" cellpadding="0" cellspacing="0" class="ziti-000">
<%
set rs = server.createobject("adodb.recordset")
sql = "select * from messages where m_show=true order by m_time desc"
rs.open sql,conn,1,1
do while not rs.EOF
%>
<tr>
<td height="22"> <span class="style18"><font color="#FF6600">我要回复</font><%=rs("m_name") %>：</span> <%=left(rs("m_rcontent"),20)%>(<%=rs("m_uptime")%>)
网页地址是http://www.xiangyilxj.com/consultation/consultation.asp
就是把这里的留言只显示5条.
<table width="540" border="0" align="center" cellpadding="0" cellspacing="0" class="ziti-000">
<%
set rs = server.createobject("adodb.recordset")
sql = "select * from messages where m_show=true order by m_time desc"
rs.open sql,conn,1,1
do while not rs.EOF
%>
<tr>
<td height="22"> <span class="style18"><font color="#FF6600">我要回复</font><%=rs("m_name") %>：</span> <%=left(rs("m_rcontent"),20)%>(<%=rs("m_uptime")%>)
sql = "select * from messages where m_show=true order by m_time desc"
改为
sql = "select top 5 * from messages where m_show=true order by m_time desc"
sql = "select top 5 * from messages where m_show=true order by m_time desc" '按时间降序
支持楼上！如果多个属性值推荐用计数器
for i=1 to rs.recordcount
sum=0
someTestcodehere...
if sum=5 then
exit for
end if
sum=sum+1
next
mngenius这位朋友说的很对，正是我想发的！